UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VVWsHcsTNJDcoiUSExZz5Rdpd23YvLHx4bovZskEdxI='
WHERE
key_id = '2f8e756746fe8495fad4b7235dfeb68fdb02d85f1e9c80c25eb2a6e5bb83ac93'
AND (
token = 'VVWsHcsTNJDcoiUSExZz5Rdpd23YvLHx4bovZskEdxI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)