UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zjV/vz33mRUF3sBtM/TcPomlORgEyYB6cBMibno0Lgg='
WHERE
key_id = '9a2fccfb765ff50f6b1d0497e164de991e876e4540743281b032a794f7470d5c'
AND (
token = 'zjV/vz33mRUF3sBtM/TcPomlORgEyYB6cBMibno0Lgg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)