UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JpXo+mS03vjZfeP3cVmp2nY56lIjm5W6SgcdAIJVH+U='
WHERE
key_id = '56870559fff591967fe37f4383a8e722fd736b6413e4f4a62b222b8e8743764a'
AND (
token = 'JpXo+mS03vjZfeP3cVmp2nY56lIjm5W6SgcdAIJVH+U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)