UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Z6D7A+Dy2xG5bc0oR7UKzaxyRliaufxC48CAzP4Casg='
WHERE
key_id = 'dd2d47504fbe073fb9b784b317a1d4a7e2b3c5bd9a05c1c496345a59e0ad5f0a'
AND (
token = 'Z6D7A+Dy2xG5bc0oR7UKzaxyRliaufxC48CAzP4Casg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)