UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'P1xyvVqjAuujj8/sS2JutzbkIBiM/kdSi3uNzSUmxPY='
WHERE
key_id = 'f176ebb7892ef887126a72d85123043eecc5474a0fa671d02bb86e5c70f60db0'
AND (
token = 'P1xyvVqjAuujj8/sS2JutzbkIBiM/kdSi3uNzSUmxPY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)