UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jK/0YZyJrr3AxPfo2u/RAcfBCKcsrTYB/rlm7DhRJFI='
WHERE
key_id = 'ef017f5cc369e9df82e7580ffa347b57c87630a435d96e75f47738009b232993'
AND (
token = 'jK/0YZyJrr3AxPfo2u/RAcfBCKcsrTYB/rlm7DhRJFI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)