UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'wp9q4kRlt/m8Yxb7H3Y3xXXvZoTW1Eg3xl0FJp9aMRs='
WHERE
key_id = '27b1b27e9386d5e4ebcc66ad29bb29fd1816f8a3fe2c9fc858dbf8189eee98a1'
AND (
token = 'wp9q4kRlt/m8Yxb7H3Y3xXXvZoTW1Eg3xl0FJp9aMRs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)