UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5JDYX4hPEYoTyVwGbmoqfvKTc8ffZEacZbywKA/FWKA='
WHERE
key_id = 'fddaf5305b86d93a845fa9fd38cc03a91a3629a21f202d8122fbdf0902cdfb3b'
AND (
token = '5JDYX4hPEYoTyVwGbmoqfvKTc8ffZEacZbywKA/FWKA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)