UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/ZhmWfc8KwCJBR7mMeYasyzJdzFG7Ayp33S4q1iwKd4='
WHERE
key_id = 'e9d345bb7ade7636173258f5b7de20cc9769f9913b0fc7778f9667c09a90bec0'
AND (
token = '/ZhmWfc8KwCJBR7mMeYasyzJdzFG7Ayp33S4q1iwKd4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)