UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qNG52cHHFK7Gu8yMfIsxQEMOpJhhdg1gybY+eIj6P6w='
WHERE
key_id = '1152e4c747c60965f478d5d7ce4af207c8fa729ba4da19aaa7d7e346e11cff50'
AND (
token = 'qNG52cHHFK7Gu8yMfIsxQEMOpJhhdg1gybY+eIj6P6w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)