UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CSX+r4iHiyyRhuBQH/6imba1DjzSrQAEyOZMYozsCkA='
WHERE
key_id = 'c7d63cb6886e22029b5f3244b32cf2350077075032e37c57730d6cf71488ace0'
AND (
token = 'CSX+r4iHiyyRhuBQH/6imba1DjzSrQAEyOZMYozsCkA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)