UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LEqWAlbXbJhxQeMAv9i2aifqPqNmqJEwuOsguVMRSvU='
WHERE
key_id = '412fb460fe8d02073054fdd1da71126d60697333712c41e2366b8c3b2f48be1e'
AND (
token = 'LEqWAlbXbJhxQeMAv9i2aifqPqNmqJEwuOsguVMRSvU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)