UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NB8E9WIFo354uUCkmr2P1N2rS+bGY/cPDwc56+aDU64='
WHERE
key_id = '4e99e868ec43728f72bef7e3dd2b1f82f3b7a9035e432bf4d77b89a9a9248426'
AND (
token = 'NB8E9WIFo354uUCkmr2P1N2rS+bGY/cPDwc56+aDU64='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)