UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nXSXGDpoJEpGq7KTIif99iI5JfDdERL9hwwi8hbBfsw='
WHERE
key_id = '8eb8d212dc220a5456851443cab6018457945e1dad07015b39f165f5616703d5'
AND (
token = 'nXSXGDpoJEpGq7KTIif99iI5JfDdERL9hwwi8hbBfsw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)