UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9L8x6Fs379CWaBi09nEgDFjyna73XPVSP6R1ASwH8tI='
WHERE
key_id = 'f4f6c281f46ddee8f83294fab812f58f9b8ecd696df1df0d37689eee65999a4f'
AND (
token = '9L8x6Fs379CWaBi09nEgDFjyna73XPVSP6R1ASwH8tI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)