UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'WWAIQB3/MycbmP2NiNnmOkuK355W1reWb4m2Zro1I40='
WHERE
key_id = 'a78a4452927e35c77a6ebd175f7935133881fb6e11cd2a831fa310b6a06e860a'
AND (
token = 'WWAIQB3/MycbmP2NiNnmOkuK355W1reWb4m2Zro1I40='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)