UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tmzJ7YtjEFrH+qihPCVhqXEnZ29Re89zpm5iVAwC4hk='
WHERE
key_id = '6e3f30a546510343f721b366dd257b1bb6a42c63330d1a82e84b2901758526ba'
AND (
token = 'tmzJ7YtjEFrH+qihPCVhqXEnZ29Re89zpm5iVAwC4hk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)