UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7hS5jQ9fmVm0jKBBrvIunoGoFhuiN/ptL9mHCaNo9Sc='
WHERE
key_id = '3986faa5c8e9d17d0682ba7ad31400844b4aa97c6d4d250803212ccc8d651f4f'
AND (
token = '7hS5jQ9fmVm0jKBBrvIunoGoFhuiN/ptL9mHCaNo9Sc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)