UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'K1JPDv6WWcmgleLR91cmY8laRNqji8O/7m0ltGsJiEc='
WHERE
key_id = '792da09ca78c1981d705f8c53ab1ec4a25770b2f3ed73843494e133cf9145386'
AND (
token = 'K1JPDv6WWcmgleLR91cmY8laRNqji8O/7m0ltGsJiEc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)