UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HZ9pOgGLCy3sBkC1/iw1xuV0u9xO8JqWAsjOtY2Zl9s='
WHERE
key_id = '188becc621d3a435e3df0047abd81c127be9eebd038a87df1159405dcdd0452d'
AND (
token = 'HZ9pOgGLCy3sBkC1/iw1xuV0u9xO8JqWAsjOtY2Zl9s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)