UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gvyQM2QXEec4BUxpfYSuRhnJiyxja/G18TieSdQ13RU='
WHERE
key_id = 'ddcee14bee5f461048b23baffe51ba0ea4e973b5882ae25abb707b971295d1fa'
AND (
token = 'gvyQM2QXEec4BUxpfYSuRhnJiyxja/G18TieSdQ13RU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)