UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3acL+rEosAgfi1aXNH5pCNASv63e4Dgfcm0sNdMmwvU='
WHERE
key_id = '78cc8c11fa4ceaee5c463418afdcb3eb86646c3f8c68a837368c968dc6656011'
AND (
token = '3acL+rEosAgfi1aXNH5pCNASv63e4Dgfcm0sNdMmwvU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)