UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hkh0cRqlrtALar1TofP4m0BEjhP7M2nxHsdJZVLD+p8='
WHERE
key_id = '077d12a51a0b095ee6b07f501bc63e291f07af839e9e11df552f5330527485f0'
AND (
token = 'hkh0cRqlrtALar1TofP4m0BEjhP7M2nxHsdJZVLD+p8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)