UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '12aVBPB1vptfOPwqtzwDbylOAJpHtIICkR0GXSy72qc='
WHERE
key_id = '6312f2e5c2e497f041098911dbc48b7609545ee9dd6f6f3ede63e08a608b4d58'
AND (
token = '12aVBPB1vptfOPwqtzwDbylOAJpHtIICkR0GXSy72qc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)